<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="hu141670">pg_stat_partition_operations</title><body><p>The <codeph>pg_stat_partition_operations</codeph> view shows details about the last operation
      performed on a partitioned table.</p><table id="hu141982"><title>pg_catalog.pg_stat_partition_operations</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1"><codeph>classname</codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">The name of the system table in the <codeph>pg_catalog</codeph> schema where
              the record about this object is stored (always <codeph>pg_class</codeph> for tables
              and partitions).</entry></row><row><entry colname="col1"><codeph>objname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the object.</entry></row><row><entry colname="col1"><codeph>objid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3"/><entry colname="col4">The OID of the object.</entry></row><row><entry colname="col1"><codeph>schemaname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the schema where the object resides.</entry></row><row><entry colname="col1"><codeph>usestatus</codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">The status of the role who performed the last operation on the object
                (<codeph>CURRENT</codeph>=a currently active role in the system,
                <codeph>DROPPED</codeph>=a role that no longer exists in the system,
                <codeph>CHANGED</codeph>=a role name that exists in the system, but its definition
              has changed since the last operation was performed).</entry></row><row><entry colname="col1"><codeph>usename</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the role that performed the operation
on this object.</entry></row><row><entry colname="col1"><codeph>actionname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The action that was taken on the object.</entry></row><row><entry colname="col1"><codeph>subtype</codeph></entry><entry colname="col2">text</entry><entry colname="col3"/><entry colname="col4">The type of object operated on or the subclass
of operation performed.</entry></row><row><entry colname="col1"><codeph>statime</codeph></entry><entry colname="col2">timestamptz</entry><entry colname="col3"/><entry colname="col4">The timestamp of the operation. This is the same timestamp that is written to
              the Greenplum Database server log files in case you need to look up more
              detailed information about the operation in the logs.</entry></row><row><entry colname="col1"><codeph>partitionlevel</codeph></entry><entry colname="col2">smallint</entry><entry colname="col3"/><entry colname="col4">The level of this partition in the hierarchy.</entry></row><row><entry colname="col1"><codeph>parenttablename</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The relation name of the parent table one level
up from this partition.</entry></row><row><entry colname="col1"><codeph>parentschemaname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the schema where the parent table
resides.</entry></row><row><entry colname="col1"><codeph>parent_relid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3"/><entry colname="col4">The OID of the parent table one level up from
this partition.</entry></row></tbody></tgroup></table></body></topic>